package com.juzi.wopu.query;

import org.apache.commons.lang3.StringUtils;

public class SysUserQuery extends BaseQuery{
	private String sUserNo;
	
	private Long iCompany;
	
	private String sMobile;
	
	public SysUserQuery() {
		super("SysUser");
	}
	
	@Override
	protected void addWhere() {
		if (StringUtils.isNotBlank(sUserNo)) {
			AddWhere("o.sUserNo like ?", "%" + sUserNo + "%");
		}
		
		if (StringUtils.isNotBlank(sMobile)) {
			AddWhere("o.sMobile like ?", "%" + sMobile + "%");
		}
		
		if (iCompany!=null) {
			AddWhere("o.iCompany = ?", iCompany);
		}
	}

	public String getsUserNo() {
		return sUserNo;
	}

	public void setsUserNo(String sUserNo) {
		this.sUserNo = sUserNo;
	}
	
	public String getSUserNo() {
		return sUserNo;
	}

	public void setSUserNo(String sUserNo) {
		this.sUserNo = sUserNo;
	}

	public Long getiCompany() {
		return iCompany;
	}

	public void setiCompany(Long iCompany) {
		this.iCompany = iCompany;
	}
	
	public Long getICompany() {
		return iCompany;
	}

	public void setICompany(Long iCompany) {
		this.iCompany = iCompany;
	}

	public String getsMobile() {
		return sMobile;
	}

	public void setsMobile(String sMobile) {
		this.sMobile = sMobile;
	}
	
	public String getSMobile() {
		return sMobile;
	}

	public void setSMobile(String sMobile) {
		this.sMobile = sMobile;
	}
	
	
	
}
